Editing Type Body Definition

Edit the type body definition under the Definition tab.

The Code Outline window displays information about the type body including declaration, etc. To show the Code Outline window, simply choose Edit -> Code Outline.

Note: Available only in Full Version.

Refresh the code outline.
Turn mouse over highlight on or off.
Show the code outline in a detail way.
Sort by type and name.
Expand the selected item.
Collapse the selected item.

The SQL statements for creating type bodies are CREATE TYPE BODY. In practice, it is best to use a CREATE OR REPLACE statement. The general form of these statements follows.

      CREATE OR REPLACE 
      TYPE BODY /*TYPE NAME*/ AS
        .... 
      END;
	

Hint: To customize the view of the editor and find out more features for sql editing, see Editor View and More Features.